UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'acWN6c/0mvIrx3ElZWjx61rTRh9l1YLbN300/k8QSNg='
WHERE
key_id = 'd4b7948e445c3a8784c2ba76ed18c36b34154aac307fba5a702f514620383c54'
AND (
token = 'acWN6c/0mvIrx3ElZWjx61rTRh9l1YLbN300/k8QSNg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)