UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P6+5E8mc5+vQcoqDiPYxCTXPNGgaNoUICQUcc/iNDsI='
WHERE
key_id = 'a3b8127ecebb4b1c7fc84e05a0d7970e77145511de53beb650ecc62131a35eaa'
AND (
token = 'P6+5E8mc5+vQcoqDiPYxCTXPNGgaNoUICQUcc/iNDsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)