UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/UcSdV7I+F7q7kpLqPJbQdIpDuTi8exz7mPHuCNlgnA='
WHERE
key_id = '370ad29835c912d9799bb4ce394175886e7d9640d5c8e89ee391992413a3c410'
AND (
token = '/UcSdV7I+F7q7kpLqPJbQdIpDuTi8exz7mPHuCNlgnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)