UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D1M7FTWimHFLs1NS2uvm2FH31aCSNOeg2uSEQe550Bs='
WHERE
key_id = '6dbdac90c19ee4a8438cf26351d72183b3a3537780098b5827c389efda053535'
AND (
token = 'D1M7FTWimHFLs1NS2uvm2FH31aCSNOeg2uSEQe550Bs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)