UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/4Kp0mwkUa80Kkk8zNxq9lymq5SFTlt1trasgRh0Z3s='
WHERE
key_id = 'c20a455d425bd16d3591bf7be96ac812cf5e1c68b8a1d814339b4d8170a5d307'
AND (
token = '/4Kp0mwkUa80Kkk8zNxq9lymq5SFTlt1trasgRh0Z3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)