UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1cn7soqmDRVqXJAD2yZEMo29NeC5keAQRztjHzCUcHo='
WHERE
key_id = '6b0c7f05bfab954c5879bdf30255ca7a259e0f08fc643d2e3f51775359321c16'
AND (
token = '1cn7soqmDRVqXJAD2yZEMo29NeC5keAQRztjHzCUcHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)