UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WHjqL8SsaY2sMitN7v5eC/OyvlG7hfGqtb35mxRi9K8='
WHERE
key_id = 'd84ccce38087030917fd9b7c4e6329db03b82295ec9c9a8d419eecf00efece84'
AND (
token = 'WHjqL8SsaY2sMitN7v5eC/OyvlG7hfGqtb35mxRi9K8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)