UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'POfRt9HcSrYo+9XLnq5d84K2xbs9In5eiN2eGAflGz8='
WHERE
key_id = 'a52fb29d8517fb4bd99f4e4ec973139eed27181caf3a35a38c7e5d748d6cecab'
AND (
token = 'POfRt9HcSrYo+9XLnq5d84K2xbs9In5eiN2eGAflGz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)