UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nxDTfQFe9/5s6Hugb8bueeGAl9N46014ruTL3donaOI='
WHERE
key_id = 'e4530e12be1ea62a7ee4798f7f320f455c78562db6ae0d3c091ee7bdf9d65270'
AND (
token = 'nxDTfQFe9/5s6Hugb8bueeGAl9N46014ruTL3donaOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)