UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zxec8FyHEN4/j70dlb150r2pfayPoVTPUpVnmIIeo0k='
WHERE
key_id = 'd6d8c8e9401be696a38d5c189a478364c232fafe01b9fd8419c0f33b438ab29b'
AND (
token = 'zxec8FyHEN4/j70dlb150r2pfayPoVTPUpVnmIIeo0k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)