UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '04iV2BdbJosIQJpEW+C0DnodY58F3vL5KsH1AGRTdUo='
WHERE
key_id = 'b33bb093d2389814e5e07f01b163b4e38d92ccbe249d1dc97b445bf2d9ba19b1'
AND (
token = '04iV2BdbJosIQJpEW+C0DnodY58F3vL5KsH1AGRTdUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)