UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0n7xkfnTtiGLneVcBvO3P7VS18DjYiUQ4X3VqD1Nupc='
WHERE
key_id = 'ef861909a926da6d9a62aa69a919ea72921675b7ca4bd8c319504dafee37730f'
AND (
token = '0n7xkfnTtiGLneVcBvO3P7VS18DjYiUQ4X3VqD1Nupc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)