UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r6mVaJuCktBtcsgH3+toPlJ0NqyBw4qumml34nndAU0='
WHERE
key_id = '29e0c2af1f31ca040aae243e84d4a06ee6db09149af9a8fa28e46875d05ac7a2'
AND (
token = 'r6mVaJuCktBtcsgH3+toPlJ0NqyBw4qumml34nndAU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)