UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gDIwmNB5xnTdh6zovUeu3zYSSB9tuxzAbU4r8WzSwpQ='
WHERE
key_id = 'bd7fbfad1760c883f529879a29c7fdb46f9b65fc045400e0d91aed2cd5f3f0bd'
AND (
token = 'gDIwmNB5xnTdh6zovUeu3zYSSB9tuxzAbU4r8WzSwpQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)