UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZjPYAwm97hUhzyljFWPmcratLVLlclgALAXO5YhnLGA='
WHERE
key_id = '420267f159104f96566ebd7ffbf70dcd9c619ab5cf3a65fc72068b35d441753b'
AND (
token = 'ZjPYAwm97hUhzyljFWPmcratLVLlclgALAXO5YhnLGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)