UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KDfSL3ZRNohcaJXTmwu9402QopbVuXGbDbJ7SicakzU='
WHERE
key_id = '4e88b36b40ca05372e0ee65d61ca13115e4ade7f14bd2f3cf77d90da52bc3970'
AND (
token = 'KDfSL3ZRNohcaJXTmwu9402QopbVuXGbDbJ7SicakzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)