UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LSHM0i7dotheOkz/K/HLvFLXTMhpM0E18Q+g0GmC/S4='
WHERE
key_id = '8c0cc10de9f2c49c70b153274c4c7bf32a049c21a3c8edd2624363198ef228d3'
AND (
token = 'LSHM0i7dotheOkz/K/HLvFLXTMhpM0E18Q+g0GmC/S4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)