UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CP+NhzBCOtbjrcyFceGn5aMtUV9uGrh7NjjksP8nbxk='
WHERE
key_id = '05c62c4924e307c49ffa8e698d832a73ff49fddf3344977dfebe3ddd889f5772'
AND (
token = 'CP+NhzBCOtbjrcyFceGn5aMtUV9uGrh7NjjksP8nbxk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)