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