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