UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gY489wnOnN0z6C6CURCf8LmkfHcU32uTViczHMvNnV4='
WHERE
key_id = '46a326d40df4c7b5465e15b01935b412c9e8c6d3e83e18eb68fa7fca3d18b08e'
AND (
token = 'gY489wnOnN0z6C6CURCf8LmkfHcU32uTViczHMvNnV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)