UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o+ttx9jz338M7P2Vj9iavqholB/tmFLD5LOpyhJ8718='
WHERE
key_id = 'd1838634ffa046cc200ee262039019181704724e470300d8b46c70571df0f4f3'
AND (
token = 'o+ttx9jz338M7P2Vj9iavqholB/tmFLD5LOpyhJ8718='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)