UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sgbyRvjsdrvQIbLR1brXCc9M1Rq3C53zOTbAECdMwfg='
WHERE
key_id = 'c073d746a1f2f56fc82cf9f19ef8a68a3f226a666f7b49308116bad022848a41'
AND (
token = 'sgbyRvjsdrvQIbLR1brXCc9M1Rq3C53zOTbAECdMwfg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)