UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mdhx1LQPqYTuwgM3emaAVb+3WEiQQjue9IE2/x9k58Y='
WHERE
key_id = 'aedd77eb347c696b200c587a538989894bc0be6037108b3c51a65ed719129df4'
AND (
token = 'Mdhx1LQPqYTuwgM3emaAVb+3WEiQQjue9IE2/x9k58Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)