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