UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8pbeAurejVmrKxbBTzjMp/E+LDDVEE6HIa0E2MhfLRA='
WHERE
key_id = 'd709e7c27c53bd17ba2d24ea9c122d761ec518ed25d4c0c33907d622abc3132f'
AND (
token = '8pbeAurejVmrKxbBTzjMp/E+LDDVEE6HIa0E2MhfLRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)