UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sVqg7tfa2t0pKQU6ElllT+DbqLNFYOykWTnpcujyXcc='
WHERE
key_id = 'd5131330bc1dc2947f9496f896cb82b0a8fc5fed1118a28be06246f655b54f1a'
AND (
token = 'sVqg7tfa2t0pKQU6ElllT+DbqLNFYOykWTnpcujyXcc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)