UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZAcpsnN/hLgLb18t9U04yjdb5wnDhiKBsXBB4opHdzU='
WHERE
key_id = '8d2cfbf492c28b14ca6fd6af3acc3f6be273aaa036ace4a9d059e0c15a9a97a1'
AND (
token = 'ZAcpsnN/hLgLb18t9U04yjdb5wnDhiKBsXBB4opHdzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)