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