UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H8Kmpxp0rovD7R1xGY7D5d4Nc7oa0J5LBaE+jdY18Tc='
WHERE
key_id = 'b0d9d5a52540aa20a3a4a4249b7bb21541f5e233520a1a7277aaf31defc91cf7'
AND (
token = 'H8Kmpxp0rovD7R1xGY7D5d4Nc7oa0J5LBaE+jdY18Tc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)