UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5p7X6i9NZmagAMioDe7MGp0NsZPzcXhTbEgd5PNmcDI='
WHERE
key_id = '1725c401886732d1332383ee9033034a0ec9e0cf9da009002f941fcc1713aafe'
AND (
token = '5p7X6i9NZmagAMioDe7MGp0NsZPzcXhTbEgd5PNmcDI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)