UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o772t9mUhXsW17hOnU16vNYhdVSDym64h6/N0/4GaJw='
WHERE
key_id = 'c56045780cf401a5ea9af00ed7c520ab52ff729fc9940f18810667e3dfd5de52'
AND (
token = 'o772t9mUhXsW17hOnU16vNYhdVSDym64h6/N0/4GaJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)