UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UK0VKjkdq4Kmbdw588hLXPclLxenWA36vxNnSt3yusI='
WHERE
key_id = '2a0ba6d3b5b4264c5492ce313cea76968c6e74c6f3a2255b9ac17713f3e2d93d'
AND (
token = 'UK0VKjkdq4Kmbdw588hLXPclLxenWA36vxNnSt3yusI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)