UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wX1LUQJkK8qiGkOnGwax5MHwyeUn6z18Eppk+4swTBk='
WHERE
key_id = 'b8dd72346053ef718cac3eb543c7ea451bfa8fa4f99cbc72958ff25c98d9ccf2'
AND (
token = 'wX1LUQJkK8qiGkOnGwax5MHwyeUn6z18Eppk+4swTBk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)