UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XEBsfPSLWXsNGc1R5+EJnVWJG2b0C2piE85VBKbWA8U='
WHERE
key_id = 'd2e7c534ddbdf010e61002c32668551deb7ba8dc1dd50aa28c94c8898f0d37a9'
AND (
token = 'XEBsfPSLWXsNGc1R5+EJnVWJG2b0C2piE85VBKbWA8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)