UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yF9b0IYC8cRh0NWI4r5U+FD2pNcu+78Y3CA+Yei2pvM='
WHERE
key_id = 'b11d78d6b94697efd82145b791835998fe17c7861962a25b8c61722f49d0824b'
AND (
token = 'yF9b0IYC8cRh0NWI4r5U+FD2pNcu+78Y3CA+Yei2pvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)